home *** CD-ROM | disk | FTP | other *** search
/ 17 Bit Software 6: Level 6 / 17 Bit - Level 6 (1998)(Epic Marketing)[!].iso / quartz / q0941.dms / q0941.adf / Examples / OldEasyCalc.calc (.txt) < prev    next >
EasyCalc Spreadsheet file  |  1997-04-10  |  2KB  |  76 lines
  1. EASY30HED1
  2. B'This worksheet demonstrates all the EasyCalc functions available:
  3. "Range to work on:
  4. "Total:
  5.     "Average:
  6. "Minimum value:
  7. "Maximum value:
  8. "'All the standard maths operators:
  9. "10 + 2
  10. "10 - 2
  11. "10 * 2
  12. "10 / 2
  13. "10 ^ 2
  14. "10 <> 5
  15. "10 = 5
  16. "10 >= 5
  17. "10 <= 5
  18. "10 > 5
  19. "10 < 5
  20. =@SUM(A4:A7)
  21. =@AVG(A4:A7)
  22. =@MIN(A4:A7)
  23. =@MAX(A4:A7)
  24. =10+2
  25. =10-2
  26. =10*2
  27. =10/2
  28. =10^2
  29. =10<>5
  30. =10=5
  31. =10>=5
  32. =10<=5
  33. =10>5
  34. =10<5
  35. "Functions:
  36.     "abs(1.2)
  37.     "atn(1.2)
  38. "cint(1.2)
  39.     "cos(1.2)
  40.     "deg(1.2)
  41.     "exp(1.2)
  42.     "fix(1.2)
  43.     "int(1.2)
  44.     "log(1.2)
  45.     "rnd(150)
  46.     "rad(300)
  47.     "sign(-3)
  48.     "sin(1.2)
  49. "sqr(49)
  50.     "tan(1.2)
  51. "vat(399.95)
  52. "Conditionals:
  53. "IF 5<15, 1 ELSE 0
  54. =@ABS(1.2)
  55. =@ATN(1.2)
  56. =@CINT(1.2)
  57. =@COS(1.2)
  58. =@DEG(1.2)
  59. =@EXP(1.2)
  60. =@FIX(1.2)
  61. =@INT(1.2)
  62. =@LOG(1.2)
  63. =@RND(150)
  64. =@RAD(300)
  65. =@SIGN(-3)
  66. =@SIN(1.2)
  67.     =@SQR(49)
  68. =@TAN(1.2)
  69. =@VAT(399.95)
  70. =@IF(5<15,1,0)
  71. '[PRESS HELP HERE]
  72. This worksheet was originally supplied with EasyCalc
  73. Classic, nearly three years ago. Here it has been converted from
  74. EasyCalc Classic, to EasyCalc Plus, and now to EasyCalc 2.0
  75. just to demonstrate how compatible they are with each other.PALL
  76.